package com.xht.main;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class MysqlJdbcConn {

	public static void main(String[] args) {
		
		String driver = "com.mysql.jdbc.Driver";
		//String  driver = "oracle.jdbc.driver.OracleDriver"
		String dbName = "test";

		 String passwrod ="19930903";
// 		String userName = "SCOTT";
		String userName = "root";

		String url = "jdbc:mysql://127.0.0.1:3306/" + dbName;
 //String url ="jdbc:oracle:thin:@localhost:1521:XE";
		String sql = "select * from user";

		try { 
		Class.forName(driver);

		Connection conn = DriverManager.getConnection(url, userName, passwrod);

		PreparedStatement ps = conn.prepareStatement(sql);

		ResultSet rs = ps.executeQuery();

		while (rs.next()) {

		System.out.println("id : " + rs.getInt(1) + " name : " + rs.getString(2) + " password : " +

		rs.getString(3)); }

		// 关闭记录集 
		if (rs != null) { try { rs.close(); }

		catch (SQLException e) { e.printStackTrace(); } }

		// 关闭声明 
		if (ps != null) { try { ps.close(); }

		catch (SQLException e) { e.printStackTrace(); } }

		// 关闭链接对象
	if (conn != null) { try { conn.close(); }

		catch (SQLException e) { e.printStackTrace(); } } }

		catch (Exception e) { e.printStackTrace(); } 
	}

}
